The following reports are found on the General tab of the Ledger and HUD Reports screen.
This report allows you to run a chart of accounts listing. The selection criteria allows you to select all or multiple funds, a specific project or all projects. You can also filter by account mask. For example, if you just want a listing of all accounts consisting of HUD account 4190, you can enter that number in the mask and the report returns all related GL account numbers. You can also select a range of account numbers. This report is used as a reference document to research GL account numbers (usually by fund). Note: This report is also accessible from the Setup Reports tab.
A report of balances in all General Ledger Accounts for a specific period/month. It displays the account, description, starting balance, debits and credits and the ending balance. You may select one or multiple funds, project, or account mask. There are three grouping levels to allow grouping by fund (if multiple funds are selected), FDS account, HUD account, line item, sub line items and/or report groups 1, 2 and 3, if used. Select the report period/month and year. You may also choose to show other report options, such as excluding accounts with zero detail and a sub-tab for selecting specific accounts. This report is usually run on a monthly basis by fund to review all account balances.
This report allows the same selection criteria as Trial Balance 1, but also includes a net change for the debits and credits, as well as YTD debits and credits. This report is usually run on a monthly basis by fund to review all account balances and to review how the housing authority is doing compared to last year at this time.
This report allows the same selection criteria as the other Trial Balances, but along with the account number and description, just displays the debit or credit balance of the accounts with lines for making adjustments to the right. This report is usually used by fee accountants to record adjustments they would like made to any accounts.
This report allows the same selection criteria as the other Trial Balances, but only displays the interfund receivable and payable accounts for each fund selected. This report is used for ensuring that the “due to” and due from” accounts for the funds selected are in balance. It is usually run on a monthly basis and when run for all funds, the balances should be a net effect of zero if interfunding has been setup correctly. See "Planning Interfund Accounts"
A listing of General Ledger accounts for a specified period of time (range – month and year) that displays activity (transactions) for all or multiple (range of) accounts. This report is used for viewing specific activity that make up an account balance in order to research. You may select activity that has been accepted (posted) or not accepted. You may choose to display extended detail and/or transactions included in the adjustment periods of 13 and 14 if desired.
The same as the Detailed General Ledger, but will print in portrait style instead of landscape style.
This report allows the same selection criteria as the other Detailed General Ledger report options and is used for viewing the detailed activity in the interfund accounts for receivables and payables, if interfunding has been setup and is being used. This report would be used to research out of balance situations between funds.
Report that can be used to view transactions that have been posted to General Ledger from other programs (subsidiary ledgers). You may select one or all funds, a specific project or account mask. You may select a range of accounts and/or a specific date range. From the journal selection list, you would select the name of the journal you want to report on. You also have sorting and column format choices available and may choose to display only accepted (posted) transactions and include subtotals. For example, if you wanted to view everything that posted to General Ledger from Section 8 from January 1st through today, you would select the S8 Journal and enter that date range. This report is used in balancing the subsidiary ledgers to the General Ledger.
This report is used as another method to produce customized financial reports from General Ledger. Each General Ledger account has a field that can be marked for “Special Code Report 1, 2, or 3”. If that field is checked, the General Ledger account will appear on this report. A reporting period can be selected for a specific month and year. There are sub-tabs for formatting the report and consolidation of funds.
This report allows you to view all the activity related to cash, including income and expenses for any one fund or multiple funds. This report can be run for any specific time period (month and year), so that you can see what your cash situation is for that time period all in one report. This report is used by management to monitor cash flow, usually on a weekly basis.
See "Trial Balance Pivot Fund Report"
This report is similar to Trial Balances 1 and 2 but has many extra features and is similar to a pivot table report created in Excel. From the selection criteria, you may select one or multiple funds. You have three grouping levels and may choose to group by FDS account, Fund, HUD account, Line Item, Report Groups and Sub Line Item. You may select an account number range and/or date range. As with other reports, you may preview the report by clicking on the “sheet of paper” icon on the tool bar. The program will display your report in a view similar to Excel. On this preview screen, you are then also able to change some of your selection criteria options. By clicking on the “+” next to each grouping, you can expand the view to see what accounts are included in that group. You may also click on “drop-down” arrows for each area to re-select anything you desire to change. If you then, click once more on the “sheet of paper” icon, you have a printed view of the report that then allows you to edit the format of the report by clicking on any of the tool bar icons. This report can be used as a regular Trial Balance or to monitor FDS accounting or any other General Ledger activity.
Copyright © Tenmast Software 2011